Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

1 Subject

Chapter 8 Excel Quiz

Chapter 8 Excel  Quiz

Q • Question 1 5 out of 5 points Now, after following the above-stated instructions, you should have enough to calculate the 95% confidence interval, (x? - E, x? + E). Select the appropriate confidence interval (rounded to two decimal places), and the correct interpretation of the confidence interval. • Question 2 5 out of 5 points Now, we want to calculate the 99% Confidence Interval for SLEEP times. The only difference should be the margin of error. So, in cell F40, type =CONFIDENCE.T(0.01,F38,35), to find the maximum margin of error for the 99% confidence interval. Again, you want to use a calculator to find the confidence interval, (x? - E, x? + E). Select the appropriate confidence interval (rounded to two decimal places), and the correct interpretation of the confidence interval.

View Related Questions

Solution Preview

Selected Answers: a. The confidence interval is (6.13, 7.07). e. We can be 95% confident that the average amount of sleep for all students lies between the bounds of our confidence interval.